// //在数据库中验证用户的信息
// const user = {
//     //查询手机号
//     queryUserTel(option){
//         return 'select * from user where tel = '+option.userTel+''
//     },
//     //查询密码
//     queryUserPwd(option){
//         return 'select * from user where (tel='+option.userTel+') and pwd = '+option.userPwd+''
//     },
//     //新增用户
//     inserData(option) {
//         let userTel = option.userTel;
//         let userPwd = option.userPwd || '669988';

//         //引入token包
//         let jwt = require('jsonwebtoken');
//         //用户信息
//         let payload = {tel:userTel};
//         //口令
//         let secret = 'dezhi';
//         //生成token
//         let token = jwt.sign(payload,secret);

//         return 'insert into user (tel,pwd,nickName,imgUrl,token) values ("' + userTel + '","' + userPwd +'","默认","1.png","'+token+'")';
//     }
// }

// exports = module.exports = user

//在数据库中验证用户的信息
const user = {
  //查询手机号
  queryUserTel(option) {
    return 'select * from user where tel = ' + option.userTel + ''
  },
  //查询密码
  queryUserPwd(option) {
    return 'select * from user where (tel=' + option.userTel + ') and pwd = ' + option.userPwd + ''
  },
  //新增用户
  inserData(option) {
    let userTel = option.userTel
    let userPwd = option.userPwd || '669988'

    //引入token包
    let jwt = require('jsonwebtoken')
    //用户信息
    let payload = { tel: userTel }
    //口令
    let secret = 'dezhi'
    //生成token
    let token = jwt.sign(payload, secret)

    return (
      'insert into user (tel,pwd,nickName,imgUrl,token) values ("' +
      userTel +
      '","' +
      userPwd +
      '","默认","1.png","' +
      token +
      '")'
    )
  },
}

exports = module.exports = user
